{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":15,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":74,"n_cols":36,"rows_kept":74,"merged":[[1,1,3,3]]}
[]
[null,"User Guide",{"$nulls":3},"Important Note:",null,"Please enable macro to use this file.",{"$nulls":4},"To enable macro:",{"$nulls":22},{"$f":"IF((COUNT(X:X)+1)<2,\"\",(COUNT(X:X)+1))","v":""}]
[{"$nulls":5},"To view the Developer tab:",{"$nulls":6},"Go to Developer tab>>Macro Security>>Enable All Macro>>OK"]
[{"$nulls":5},"Go to File>>Options>>Customize Ribbon>>Check Developer>>OK",{"$nulls":6},">>Save>>Close the file>>Re-open the file",{"$nulls":6},"V.1"]
[]
[null,"STEP 1:"]
[]
[null,"Download broker report and find the file with _Realized Summary and RENAME the file to a shorter name"]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Go to \"CONVERTER\" sheet and click \"SELECT SOURCE FILE\", locate the file, and click OK"]
{"$rows_empty":15}
[null,"STEP 3:"]
[null,"Click COPY from CONVERTER sheet."]
{"$rows_empty":11}
[null,"STEP 4:"]
[null,"Paste your trade data in your Trading Journal"]
{"$rows_empty":23}
[null,"You can check out the sample of our trading journal at rocketsheets.com, contact us or visit our website for more info."]

{"sheet":"CONVERTER","index":1,"n_rows":7,"n_cols":42,"rows_kept":7}
[{"$nulls":5},{"$f":"IFERROR(IF((F2-C6+1)<8,8,(F2-C6+1)),8)","v":8},{"$f":"IF(COUNT(AA:AA)+5<6,6,COUNT(AA:AA)+5)","v":6},null,{"$f":"\"u\"&COUNT(AA:AA)+5","v":"u5"},"Deposits & Withdrawals",{"$nulls":16},"Developed by AA Excel Spreadsheets, Interactive Brokers Ledger Converter v.1"]
[{"$nulls":5},{"$f":"C6+F3+4","v":{"$error":"#N/A"}},null,null,"F","G","H","I","J","K","L","M","N","O","P","Q"]
[{"$nulls":5},{"$f":"COUNTIF(Sheet1!A:A,\"trades\")","v":0},{"$f":"MATCH(H5,INDIRECT(\"Sheet1!\"&H3&\":\"&H3),0)","v":{"$error":"#N/A"}},{"$f":"C6-1","v":{"$error":"#N/A"}},6,7,8,9,10,11,12,13,14,15,16,17,{"$nulls":12},"D:\\00-SPREADSHEET\\02 - FREE EXCELS PRODUCTS\\25-Interactive broker\\Version 00\\04 - Sample Ledger\\test.csv"]
[{"$nulls":3},{"$f":"INDEX(I2:O2,MATCH(G3+1,I3:O3,0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(I2:O2,MATCH(G3,I3:O3,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:O2,MATCH(G3+2,I3:O3,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:O2,MATCH(G3+3,I3:O3,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:O2,MATCH(G3+2,I3:O3,0))","v":{"$error":"#N/A"}},{"$f":"MATCH(L5,INDIRECT(\"Sheet1!\"&H3&\":\"&H3),0)","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:Q2,MATCH(L4,I3:Q3,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:Q2,MATCH(O4,I3:Q3,0))","v":{"$error":"#N/A"}},{"$f":"MATCH(O5,INDIRECT(\"Sheet1!\"&H3&\":\"&H3),0)","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:T2,MATCH(Q4,I3:T3,0))","v":{"$error":"#N/A"}},{"$f":"MATCH(P5,INDIRECT(\"Sheet1!\"&H3&\":\"&H3),0)","v":{"$error":"#N/A"}},{"$nulls":15},"test.csv"]
[null,"No.","match","Date/Time",null,null,"date","symbol","quantity","T. Price","quantity","Comm/Fee","unique","matach","basis","Code",{"$nulls":5},"combine","stock","action","price","shares","DATE","STOCK","ACTION","PRICE","SHARES","FEES",{"$f":"LEFT(AG4,LEN(AG4)-4)","v":"test"},{"$nulls":7},"28/04/20",{"$f":"VALUE(AO5)","v":{"$error":"#VALUE!"}}]
[{"$f":"SUMIFS(L:L,D:D,D6,H:H,H6)","v":{"$error":"#N/A"}},1,{"$f":"MATCH(\"trades\",Sheet1!A:A,0)+1","v":{"$error":"#N/A"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(INDIRECT(\"Sheet1!\"&$D$4&C6),\",\",\"\"))+M6,\"\")","v":""},{"$f":"IF(V6=1,B6,\"\")","v":1},{"$f":"SMALL(E:E,B6)+5","v":6},{"$f":"IFERROR(SMALL(D:D,B6),\"\")","v":""},{"$f":"INDIRECT(\"Sheet1!\"&$H$4&C6)","v":{"$error":"#N/A"}},{"$f":"IF(AND(INDIRECT(\"Sheet1!\"&$I$4&C6)<0,INDIRECT(\"Sheet1!\"&$N$4&C6)<0,LEFT(INDIRECT(\"Sheet1!\"&$P$4&C6),1)=\"O\"),\"SHORT\",\nIF(AND(INDIRECT(\"Sheet1!\"&$I$4&C6)>0,INDIRECT(\"Sheet1!\"&$N$4&C6)>0,LEFT(INDIRECT(\"Sheet1!\"&$P$4&C6),1)=\"C\"),\"COVER\",\nIF(AND(INDIRECT(\"Sheet1!\"&$I$4&C6)>0,INDIRECT(\"Sheet1!\"&$N$4&C6)>0,LEFT(INDIRECT(\"Sheet1!\"&$P$4&C6),1)=\"O\"),\"BUY\",\"SELL\")))","v":{"$error":"#N/A"}},{"$f":"VALUE(INDIRECT(\"Sheet1!\"&$J$4&C6))","v":{"$error":"#N/A"}},{"$f":"ABS(INDIRECT(\"Sheet1!\"&$K$4&C6))","v":{"$error":"#N/A"}},{"$f":"ABS(INDIRECT(\"Sheet1!\"&$M$4&C6))","v":{"$error":"#N/A"}},{"v":1e-05,"d":"0.00001"},{"$f":"IF(G6=\"\",\"\",MATCH(G6,D:D,0))","v":""},{"$nulls":7},{"$f":"COUNTIFS(D$6:D6,D6,H$6:H6,H6)","v":1},{"$f":"INDEX(H:H,N6)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(I:I,$N6)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(J:J,$N6)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(K:K,$N6)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNT(G6)=1,G6,\"\")","v":""},{"$f":"IFERROR(W6,\"\")","v":""},{"$f":"IFERROR(X6,\"\")","v":""},{"$f":"IFERROR(Y6,\"\")","v":""},{"$f":"IFERROR(Z6,\"\")","v":""},{"$f":"IFERROR(INDEX(A:A,$N6),\"\")","v":""}]
[{"$f":"SUMIFS(L:L,D:D,D7,H:H,H7)","v":{"$error":"#N/A"}},{"$f":"B6+1","v":2},{"$f":"C6+1","v":{"$error":"#N/A"}},{"$f":"IFERROR(VALUE(SUBSTITUTE(INDIRECT(\"Sheet1!\"&$D$4&C7),\",\",\"\"))+M7,\"\")","v":""},{"$f":"IF(V7=1,B7,\"\")","v":""},{"$f":"SMALL(E:E,B7)+5","v":{"$error":"#NUM!"}},{"$f":"IFERROR(SMALL(D:D,B7),\"\")","v":""},{"$f":"INDIRECT(\"Sheet1!\"&$H$4&C7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VALUE(INDIRECT(\"Sheet1!\"&$J$4&C7))","v":{"$error":"#N/A"}},{"$f":"ABS(INDIRECT(\"Sheet1!\"&$K$4&C7))","v":{"$error":"#N/A"}},{"$f":"ABS(INDIRECT(\"Sheet1!\"&$M$4&C7))","v":{"$error":"#N/A"}},{"$f":"M6+0.00001","v":{"v":2e-05,"d":"0.00002"}},{"$f":"IF(G7=\"\",\"\",MATCH(G7,D:D,0))","v":""},{"$nulls":7},{"$f":"COUNTIFS(D$6:D7,D7,H$6:H7,H7)","v":2},{"$f":"INDEX(H:H,N7)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(I:I,$N7)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"INDEX(K:K,$N7)","v":{"$error":"#VALUE!"}},"",{"$f":"IFERROR(W7,\"\")","v":""},{"$f":"IFERROR(X7,\"\")","v":""},{"$f":"IFERROR(Y7,\"\")","v":""},{"$f":"IFERROR(Z7,\"\")","v":""},{"$f":"IFERROR(INDEX(A:A,$N7),\"\")","v":""}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}